Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransactionLineItem(TR_LTM_RTL_TRN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | RetailTransactionLineItem(TR_LTM_RTL_TRN) |
ResourceOverrideSequenceNumber (PK) | Line number (incremental counter) | AI_OVR_RS | Number | integer | |
ResourceID (FK) | A unqiue system assigned identifier for the action to which access may be granted to some Operators and Workstations. | ID_RS | Identity | integer | Resource(PA_RS) |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
OperatorID (FK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
Timestamp | The date and time that a transaction line item is being overridden. | TS_LTM_RTL_TRN_OVR | AuditDateTime | datetime | |
EntryMethodCode | A code denoting how the overriding OperatorID was entered. e.g. Keyed, Scanned, MCR, SmartCard, etc... | LU_MTH_ENR | Code2 | char(2) | |
OverrideApprovalCode | Approval code entered by the overriding Operator to complete the override authorization. | CD_APVL_OVR | Code4 | char(4) | |
ApproverName | The name of the person assigned to the OperatorID that was used to approve this LineItemResourceOverride | NM_APRVR | Name | varchar(40) | |
Description | A narrative describing the access control override, and the reasons for granting it. | DE_OVR | DescriptionNarrative | varchar(4000) | |